with
	member [Measures].[VAA1_CODE] as [Product].[Category].currentmember.name
	member [Measures].[VAA1_LABEL] as [Product].[Category].currentmember.properties("CAPTION")
	member [Measures].[VAA2_CODE] as [Product].[Subcategory].currentmember.name
	member [Measures].[VAA2_LABEL] as [Product].[Subcategory].currentmember.properties("CAPTION")
	member [Measures].[VAA3_CODE] as [Product].[Product].currentmember.name
	member [Measures].[VAA3_LABEL] as [Product].[Product].currentmember.properties("CAPTION")
	
	member [Measures].[HAA1_CODE] as [Date].[Calendar Year].currentmember.name
	member [Measures].[HAA1_LABEL] as [Date].[Calendar Year].currentmember.properties("CAPTION")
	member [Measures].[HAA2_CODE] as [Date].[Calendar Quarter of Year].currentmember.name
	member [Measures].[HAA2_LABEL] as [Date].[Calendar Quarter of Year].currentmember.properties("CAPTION")
	member [Measures].[HAA3_CODE] as [Date].[Month of Year].currentmember.name
	member [Measures].[HAA3_LABEL] as [Date].[Month of Year].currentmember.properties("CAPTION")
	
	member [Measures].[RESULT1] as [Measures].[Order Count]
	member [Measures].[RESULT2] as [Measures].[Sales Amount]
	member [Measures].[RESULT3] as [Measures].[Average Sales Amount]
select {
	[Measures].[VAA1_CODE],
	[Measures].[VAA1_LABEL],
	[Measures].[VAA2_CODE],
	[Measures].[VAA2_LABEL],
	[Measures].[VAA3_CODE],
	[Measures].[VAA3_LABEL],
	
	[Measures].[HAA1_CODE],
	[Measures].[HAA1_LABEL],
	[Measures].[HAA2_CODE],
	[Measures].[HAA2_LABEL],
	[Measures].[HAA3_CODE],
	[Measures].[HAA3_LABEL],
	
	[Measures].[RESULT1],
	[Measures].[RESULT2],
	[Measures].[RESULT3]
}
 on columns,
 order(
	non empty (
	[Date].[Calendar Year].[Calendar Year] * 
	[Date].[Calendar Quarter of Year].[Calendar Quarter of Year] *
	[Date].[Month of Year].[Month of Year] * 
	[Product].[Category].[Category] *
	[Product].[Subcategory].[Subcategory]),
	
 )
 on rows
from [Adventure Works]